package c.x.jy.dao.dao;

import c.x.jy.dao.dto.ClubEvaluationEntityDto;
import c.x.jy.dao.entity.ClubEvaluationEntity;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 
 * 
 * @author amwhyh
 * @email xxx@xx.com
 * @date 2021-07-12 10:32:15
 */
@Mapper
public interface ClubEvaluationDao extends BaseMapper<ClubEvaluationEntity> {

    @Select("select ce.*,m.nickname as memberName,m.headimgurl as memberHeadimgurl from t_club_evaluation ce LEFT JOIN t_member m on ce.member_id=m.id  ${ew.customSqlSegment} order by create_date desc")
    IPage<ClubEvaluationEntityDto> querypage(IPage<ClubEvaluationEntity> page,@Param(Constants.WRAPPER)  QueryWrapper<ClubEvaluationEntity> query);
}

